from app import db


class Msg(db.Model):
    __tablename__ = "msg"
    id = db.Column(db.Integer, primary_key=True)
    周 = db.Column(db.String(20))
    邮件营销 = db.Column(db.String(20))
    联盟广告 = db.Column(db.String(20))
    视频广告 = db.Column(db.String(20))
    直接访问 = db.Column(db.String(20))
    搜索引擎 = db.Column(db.String(20))


if __name__ == "__main__":
    msg = Msg()
    all = db.session.query(Msg.邮件营销).all()
    print(type(all[1][0]))
